﻿<?xml version="1.0" encoding="utf-8" ?>
<!--
$name: name of the sqlparameter in sql query
$value: original value in sql query for the sql parameter
$oldsql: original sql
$newsql: original sql without constants
-->
<templates>
<codeTemplate name="default">
  <CodeStart>
    #region sqlquery
    //$oldsql
    string query=@"$newsql";
  </CodeStart>
  <SqlParameterStart>
    SqlParameterCollection colection = new SqlParameterCollection();
  </SqlParameterStart>
  <SqlParameter>
    colection.Add(new SqlParameter( $name, $value ));
  </SqlParameter>
  <SqlParameterEnd>
  </SqlParameterEnd>
  <CodeEnd>
    #endregion
  </CodeEnd>
</codeTemplate>
</templates>
